--jUserGetByPara @deportment = 1
ALTER PROC jUserGetByPara(
	@Id INT = 0,
	@Email NVARCHAR(80) = '',
	@Mobile NVARCHAR(20) = '',
	@Deportment INT = 0
)
AS
BEGIN
	SELECT * FROM dbo.tbUser
	WHERE 1 = 1
		AND Id = ISNULL(NULLIF(@Id,0),Id)
		AND Email = ISNULL(NULLIF(@Email,''),Email)
		AND Mobile = ISNULL(NULLIF(@Mobile,''),Mobile)
		AND Deportment = ISNULL(NULLIF(@Deportment,0),Deportment)
END